package com.so206.mapper;

import com.so206.po.SystemOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

@Mapper
public interface SystemOrderMapper {
    int deleteByPrimaryKey(Long id);

    int insert(SystemOrder record);

    int insertSelective(SystemOrder record);

    SystemOrder selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(SystemOrder record);

    int updateByPrimaryKey(SystemOrder record);

    SystemOrder findOrderByOutOrderId(@Param("id") String id);

    List<SystemOrder> selectOrderByClause(@Param("status") Integer status, @Param("sett") Integer sett);

    SystemOrder find_orderByTradeNo(@Param("to") String to);

    List<SystemOrder> selectByStatusIsNotifyType(@Param("status") Integer status, @Param("is_notify") Integer is_notify, @Param("order_type") Integer order_type, @Param("create_time") Date create_time);

    void deleteByCreateTime(@Param("create_time") Date create_time);

    List<SystemOrder> selectByPayTypeTimes(@Param("payType") Integer payType, @Param("start_time") Date start_time, @Param("stop_time") Date stop_time);

    List<SystemOrder> selectByPayConnetTypePayConnet(@Param("id") Long id, @Param("i") Integer i);

}